Skip Headers

Oracle® Text Application Developer's Guide 10g Release 2 (10.2) Part Number B14217-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P Q R S T U V W X Z

## A

  ABOUT query, 4.2.1
    adding for your language, 9.4.1
    case-sensitivity, 4.1.8.2
    definition, 4.1.6
  accents
    indexing characters with, 3.2.8.2
  ACCUM operator, 4.2.2
  ADD_STOPCLASS procedure, 3.3.4.3
  ADD_STOPTHEME procedure, 3.3.4.3, 3.3.4.3
  ADD_STOPWORD procedure, 3.3.4, 3.3.4.3
  ADD_SUB_LEXER procedure
    example, 3.3.2.5
  administration tool, 10.6
  ALTER INDEX statement
    rebuilding index, 3.4.4
    resuming failed index, 3.4.3
  alternate spelling, 3.2.8.3
  alternative grammar, 4.1.18
  alternative scoring, 4.1.17
  AND operator, 4.2.2
  application
    sample, A, B
  applications, updating, 11
  attribute
    searching XML, 8.3.2
  attribute sections, 8.1.2.5
  AUTO_FILTER filter, 3.1.3.2, 3.2.2, 3.2.4, 7.8.4
  AUTO_SECTION_GROUP object, 8.1.1.1
  automatic sections, 8.3.1

## B

  background DML, 10.5
  base-letter conversion, 3.2.8.2
  BASIC_LEXER, 3.2.5
  BASIC_SECTION_GROUP object, 8.1.1.1
  BFILE column, 3.2.1.1
    indexing, 3.3.6.2
  BINARY format column value, 3.2.2.2
  BLOB column, 3.2.1.1
    indexing, 3.3.6.2
  blocking operations
    tuning queries with, 7.6
  bypassing rows, 3.2.3

## C

  cantaloupe dispenser, A.1
  case-sensitive
    ABOUT query, 4.1.8.2
    indexing, 3.2.7
    queries, 4.1.8
    thesaurus, 9.1.2
  catalog application, 2.4
    example, 2.4
  CATSEARCH, 4.1.2
    creating index for, 3.3.7.3
    operators, 4.3
    SQL example, 4.1.2.1
    structured query, 4.1.2.1
  CATSEARCH queries, 2.4
  CHAR column, 3.2.1.1
  Character Large Object (CLOB), 2.3
  character set
    indexing, 3.2.4
    indexing mixed, 3.2.4.1
  character set column, 3.2.1.6
  charset column, 3.2.4.1
  CHARSET_FILTER, 3.1.3.2, 3.2.4
  Chinese indexing, 3.2.8.5
  CHINESE_VGRAM_LEXER, 3.2.8.5
  classification
    Decision Tree (supervised), 6.4.1
    rule-based, 6.3
    simple, see rule-based classification
    supervised, 6.4
    SVM (supervised), 6.4.2
    unsupervised
  classification application
    example, 2.5
  CLOB (Character Large Object) datatype, 2.3
  CLOB column, 3.2.1.1
    indexing, 3.3.6.2
  clustering, see unsupervised classification
  column types
    supported for indexing, 3.2.1.1
  composite words
    indexing, 3.2.8.4
  concordance, 5.1.3.3
  CONTAINS
    operators, 4.2
    PL/SQL example, 4.1.1.2
    query, 4.1.1
    SQL example, 4.1.1.1
    structured query, 4.1.1.3
  CONTAINS query, 2.3
  CONTEXT grammar, 4.2
  CONTEXT index
    about, 3.1.1
    creating, 3.3.1, 3.3.6
    HTML example, 2.3, 3.3.6.3, A.2.2
  couch, self-tipping, A.1
  counting hits, 4.2.10
  CREATE INDEX statement, 3.3.5
  CREATE TABLE permissions, 11.2.1.7
  CREATE_INDEX_SCRIPT, 10.4
  CREATE_POLICY_SCRIPT, 10.4, 10.4
  CREATE_STOPLIST procedure, 3.3.4, 3.3.4.3
  CTX_CLS.TRAIN procedure, 6.4
  CTX_DDL.SYNC_INDEX procedure, 2.3, 3.5.2.1
  CTX_DOC.POLICY_SNIPPET procedure, 5.1.3.3
  CTX_DOC.SNIPPET procedure, 5.1.3.3
  CTX_INDEX_ERRORS view, 3.4.1, 10.2
  CTX_OUTPUT.END_QUERY_LOG, 4.1.19
  CTX_OUTPUT.START_QUERY_LOG, 4.1.19
  CTX_PENDING view, 10.2
  CTX_REPORT, 3.5.3.5
  CTX_REPORT package, 10.4
  CTX_REPORT_QUERY_LOG_SUMMARY, 4.1.19
  CTX_REPORT_TOKEN_TYPE, 10.4
  CTX_REPORT.CREATE_INDEX_SCRIPT, 10.4
  CTX_REPORT.CREATE_POLICY_SCRIPT, 10.4, 10.4
  CTX_REPORT.DESCRIBE_INDEX, 10.4
  CTX_REPORT.DESCRIBE_POLICY, 10.4
  CTX_REPORT.INDEX_SIZE, 10.4
  CTX_REPORT.INDEX_STATS, 10.4
  CTX_REPORT.QUERY_LOG_SUMMARY, 10.4
  CTX_REPORT.TOKEN_INFO, 10.4
  CTX_THES package
    about, 9.1.1.1
  CTX_USER_INDEX_ERRORS view, 3.4.1, 10.2
  CTX_USER_PENDING view, 10.2
  CTXAPP role, 2.2, 10.1
  CTXCAT grammar, 4.3
  CTXCAT index
    about, 3.1.1
    about performance, 7.7.17
    automatic synchronization, 2.4
    creating, 2.4
    example, 3.3.7
  ctxkbtc
    example, 9.3.2.5
  ctxload
    load thesaurus example, 9.1.1.3, 9.3.1, 9.3.2.4
  CTXRULE index, 6.3.2
    about, 3.1.1
    allowable queries, 6.3.2
    creating, 2.5.1, 3.3.8
    lexer types, 6.3.2
    limitations, 6.3.2
    parameters, 6.3.2
  CTXSYS user, 10.1
    and DBA permissions, 11.2.1.1
    and effective user, 11.2.1.3
    and procedure ownership, 11.2.1.4
    CREATE TABLE permissions, 11.2.1.7
    migrating procedures owned by, 11.2.1.2, 11.2.2
    preferences, 11.2.1.4
    synching and optimizing other indexes, 11.2.1.5, 11.2.1.6
  CTXXPATH index, 1.6.3.2
    about, 3.1.1

## D

  data storage
    index default, 3.3.6.2
    preference example, 3.3.2.1.4
  datastore
    about, 3.1.3.1, 3.3.1
  DATE column, 3.3.6.2
  DBA permissions and CTXSYS, 11.2.1.1
  DBMS_JOB.SUBMIT procedure, 3.5.2.1
  Decision Tree supervised classification, 6.4.1
  default thesaurus, 9.1.4
  DEFAULT_INDEX_MEMORY, 7.8.2
  defaults
    index, 3.3.6.2
  DESCRIBE_INDEX, 10.4
  DETAIL_DATASTORE, 3.2.1.2.1
    about, 3.2.1.8
  diacritical marks
    characters with, 3.2.8.2
  DIRECT_DATASTORE, 3.2.1.2.1
    about, 3.2.1.8
    example, 3.3.2.1.1
  DML
    view pending, 3.5.1
  DML processing
    background, 10.5
  DML queue, 10.2
  document
    classification, 3.3.8, 6
  document format
    affect on index performance, 7.8.4
    affect on performance, 7.7.5
  document formats
    filtering, 3.2.2
    supported, 3.2.1.7
  document invalidation, 3.5.3.3
  document presentation
    about, 5.3
  document sections, 3.3.3
  document services
    about, 5.3
  DOMAIN_INDEX_NO_SORT hint
    better throughput example, 7.3.2
  drjobdml.sql script, 3.5.2.1
  DROP INDEX command, 3.4.2
  DROP_STOPLIST procedure, 3.3.4.3
  dropping an index, 3.4.2

## E

  effective user, 11.2.1.3
  EQUIV operator, 4.2.2
  errors
    DML, 10.2
    viewing, 3.4.1
  explain plan, 4.1.10
  exporting statistics, 7.1
  extensible query optimizer, 7.1

## F

  feedback
    query, 4.1.9
  field section
    definition, 8.1.2.2
    nested, 8.1.2.2.2
    repeated, 8.1.2.2.3
    visible and invisible, 8.1.2.2.1
  file paths
    storing, 3.2.1.3
  FILE_DATASTORE, 3.1.3.1
    about, 3.2.1.3, 3.2.1.8
    example, 3.3.2.1.4
  filter
    about, 3.1.3.2, 3.3.1
  filtering
    custom, 3.2.2.3
    index default, 3.3.6.2
    to plain text and HTML, 5.3
  filtering documents, 3.2.2
  FIRST_ROWS hint, 4.2.9
    better response time example, 7.2.2.1
    better throughput example, 7.3.2
  format column, 3.2.1.6, 3.2.2.2, 3.2.3
  formats
    filtering, 3.2.2
    supported, 3.2.1.7
  fragmentation of index, 3.5.3.2, 7.9.2
    viewing, 3.5.3.5
  full themes
    obtaining, 5.2.1.2.2
  functional lookup, 7.7.6
  fuzzy matching, 3.2.9
    default, 3.3.6.2
  fuzzy operator, 4.2.5

## G

  garbage collection, 3.5.3.3
  German
    alternate spelling, 3.2.8.3
    composite words, 3.2.8.4
  gist
    definition, 5.2
    example, 5.2.2.1
  GIST procedure, 5.2.2
  grammar
    alternative, 4.1.18
    CTXCAT, 4.3
  grammar CONTEXT, 4.2
  granting roles, 2.2, 10.1.3

## H

  HASPATH operator, 8.3.4
    examples, 8.3.4.8
  HFEEDBACK procedure, 4.1.9
  highlighting
    about, 5.3
    overview, 5.1
  highlighting documents, 2.3
  highlighting text, 5.1.1
  highlighting themes, 5.1.2
  hit count, 4.2.10
  home air dirtier, A.1
  HTML
    filtering to, 5.3
    indexing, 3.3.2.2, 8.1.1.1
    indexing example, 2.3, A.2.2
    searching META tags, 8.2.2
    zone section example, 3.3.3.1, 8.2.1
  HTML_SECTION_GROUP object, 3.3.3.1, 8.1.1.1, 8.2.1
    with NULL_FILTER, 2.3, 3.3.2.2, A.2.2

## I

  IGNORE
    format column value, 3.2.3
  IGNORE format column value, 3.2.2.2
  importing statistics, 7.1
  index
    about, 3.1
    creating, 3.3, 3.3.5
    dropping, 3.4.2
    getting report on, 10.4
    optimizing, 3.5.3, 3.5.3.6
    rebuilding, 3.4.4
    statistics on, 10.4
    structure, 3.1.2, 3.5.3.1
    synchronizing, 3.5.2, 10.5
    viewing information on, 10.4
  index defaults
    general, 3.3.6.2
  index engine
    about, 3.1.3.5
  index errors
    viewing, 3.4.1
  index fragmentation, 3.5.3.2, 7.9.2
  index maintenance, 3.4
  index memory, 7.8.2
  index synchronization, 2.3
  index types
    choosing, 3.1.1
  INDEX_SIZE, 10.4
  INDEX_STATS, 10.4
  INDEX_STATS procedure, 3.5.3.5
  indexed lookup, 7.7.6
  indexing
    and views, 3.1.7
    bypassing rows, 3.2.3
    considerations, 3.2
    overview of process, 3.1.3
    parallel, 3.1.6, 7.8.5
    resuming failed, 3.4.3
    special characters, 3.2.6
  indexing performance
    FAQs, 7.8
    parallel, 7.8.6
  indexing time, 7.8.1
  INPATH operator, 8.3.4
    examples, 8.3.4.2
  INSO_FILTER (deprecated), 11.1.1
  INSO_OUTPUT_FORMATTING attribute (deprecated), 11.1.1
  INSO_TIMEOUT attribute (deprecated), 11.1.1
  INSOFILTER directive (deprecated), 11.1.1

## J

  Japanese indexing, 3.2.8.5
  JAPANESE_LEXER, 3.2.8.5
  Jdeveloper
    Text wizard, 2.3.1, A, B

## K

  knowledge base
    about, 9.4
    augmenting, 9.3.2
    linking new terms, 9.3.2.3
    supported character set, 9.4
    user-defined, 9.4.1
  Korean indexing, 3.2.8.5
  KOREAN_MORPH_LEXER, 3.2.8.5

## L

  language
    default setting for indexing, 3.3.6.2
  language specific features, 3.2.8
  languages
    indexing, 3.2.5
  language-specific knowledge base, 9.4.1
  lexer
    about, 3.1.3.4, 3.3.1
    and CTXRULE, 6.3.2
  list of themes
    definition, 5.2
    obtaining, 5.2.1
  loading text
    about, 3.2.1
  LOB columns
    improving query performance, 7.7.11
    indexing, 3.3.6.2
  local partitioned index, 7.7.14
    improved response time, 7.2.3
  location of text, 3.2.1
  logical operators, 4.2.2

## M

  magnet, pet see pet magnet
  maintaining the index, 3.4
  marked-up document
    obtaining, 5.1.3.1
  MARKUP procedure, 2.3, 5.1.3.1
  MATCHES
    about, 4.1.3
    PL/SQL example, 3.3.8.3, 4.1.3.2
    SQL example, 4.1.3.1
  MATCHES operator, 2.5.1, 6.3.1
  materialized views, indexes on
  MAX_INDEX_MEMORY, 7.8.2
  MDATA operator, 8.1.2.4
  MDATA section, 8.1.2.4
  memory allocation
    index synchronization, 7.9.3
    indexing, 7.8.2
    querying, 7.7.10
  META tag
    creating zone section for, 8.2.2.1
  metadata
    adding, 8.1.2.4
    removing, 8.1.2.4
    section, 8.1.2.4
  migrating from previous releases, 11
  migrating procedures, 11.2.1.2
  migrating to previous releases, 11.2.2
  mixed formats
    filtering, 3.2.2.2
  mixed query, 8.1.2.4
  MULTI_COLUMN_DATASTORE, 3.2.1.2.1
    about, 3.2.1.8
    example, 3.3.2.1.2
  MULTI_LEXER, 3.2.5.2
    example, 3.3.2.5
  multi-language columns
    indexing, 3.2.5.2
  multi-language stoplist
    about, 3.3.4.1
  multiple CONTAINS
    improving performance, 7.7.12
  MVIEW see materialized views

## N

  NCLOB column, 3.3.6.2
  NEAR operator, 4.2.4
  NEAR_ACCUM operator, 4.2.4
  nested zone sections, 8.1.2.1.3
  NESTED_DATASTORE, 3.2.1.2.1
    about, 3.2.1.8
  NEWS_SECTION_GROUP object, 8.1.1.1
  NOT operator, 4.2.2
  NULL_FILTER, 3.1.3.2
    example, 2.3, 3.3.2.2, A.2.2
  NULL_SECTION_GROUP object, 8.1.1.1
  NUMBER column, 3.3.6.2

## O

  offset information
    highlight, 5.1.3.2
  operator
    MDATA, 8.1.2.4
  operators
    CATSEARCH, 4.3
    CONTAINS, 4.2
    logical, 4.2.2
    thesaurus, 9.1.1.2
  optimizing index, 3.5.3
    example, 3.5.3.6
    single token, 3.5.3.4
  optimizing queries, 4.2.9, 7.1
    FAQs, 7.7
    response time, 7.2
    statistics, 7.1
    throughput, 7.3
    with blocking operations, 7.6
  OR operator, 4.2.2
  ora
    contains, 1.6.2
  Oracle Enterprise Manager, 10.6
  Oracle XML DB, 1.6
  Oracle9i Text Manager, 10.6
  out of line LOB storage
    improving performance, 7.7.11

## P

  parallel indexing, 3.1.6, 7.8.5
    partitioned table, 7.8.6
  parallel queries, 7.5, 7.7.15
  paramstring for CREATE INDEX, 3.3.5
  partitioned index, 7.7.14
    improved response time, 7.2.3
  path section searching, 8.3.4
  PATH_SECTION_GROUP
    example, 8.3.4.1
  pending DML
    viewing, 3.5.1
  pending updates, 10.2
  performance tuning
    indexing, 7.8
    querying, 7.7
    updating index, 7.9
  pet magnet, A.1
    gist, 5.3.3
    illustration, 5.3
    themes, 5.3.2
  phrase query, 4.1.4
  pizza shredder, A.1
  plain text
    indexing with NULL_FILTER, 3.3.2.2
  plain text filtering, 5.3
  PL/SQL functions
    calling in contains, 4.2.8
  preferences
    and CTXSYS, 11.2.1.4
    creating (examples), 3.3.2
    creating with admin tool, 10.6
    dropping, 3.4.5
  previous releases, migrating from, 11
  previous releases, migrating to, 11.2.2
  printjoins character, 3.2.6.1
  PROCEDURE_FILTER, 3.2.2.3
  PSP application, A.2, B.2

## Q

  query
    ABOUT, 4.2.1
    analysis, 4.1.19
    blocking operations, 7.6
    case-sensitive, 4.1.8
    CATSEARCH, 4.1.2, 4.1.2.1
    CONTAINS, 4.1.1
    counting hits, 4.2.10
    CTXRULE, 6.3.2
    getting report on, 10.4
    log, 4.1.19
    MATCHES, 4.1.3
    mixed, 8.1.2.4
    optimizing for throughput, 7.3
    overview, 4.1
    parallel, 7.5
    speeding up with MDATA, 8.1.2.4
    viewing information on, 10.4
    viewing log of, 10.4
  query analysis, 4.1.19
  query application
    example, 2.3
    sample, 1.3.1
  query explain plan, 4.1.10
  query expressions, 4.1.7
  query features, 4.1.20
  query feedback, 4.1.9
  query language, 4.1.16
  query log, 4.1.19, 10.4
  query optimization, 4.2.9
    FAQs, 7.7
    response time, 7.2
  query performance
    FAQs, 7.7
  query relaxation, 4.1.15
  query rewrite, 4.1.14
  query template, 4.2.6, 4.3.1
  QUERY_LOG_SUMMARY, 10.4
  queue
    DML, 10.2

## R

  rebuilding an index, 3.4.4
  relaxing queries, 4.1.15
  REMOVE_SQE procedure, 4.2.7.1
  REMOVE_STOPCLASS procedure, 3.3.4.3
  REMOVE_STOPTHEME procedure, 3.3.4.3
  REMOVE_STOPWORD procedure, 3.3.4, 3.3.4.3
  response time
    improving, 7.2
    optimizing for, 4.2.9
  result buffer size
    increasing, 7.6
  resuming failed index, 3.4.3
  rewriting queries, 4.1.14
  roles
    granting, 2.2, 10.1.3
    system-defined, 10.1
  rule-based classification, 6.3

## S

  sample application, A, B
  scoring
    alternative, 4.1.17
  searching
    XML, 1.6
  section
    attribute, 8.1.2.5
    field, 8.1.2.2
    groups and types, 8.1.2
    HTML example, 3.3.3
    MDATA, 8.1.2.4
    nested, 8.1.2.1.3
    overlapping, 8.1.2.1.2
    repeated zone, 8.1.2.1.1
    special, 8.1.2.6
    stop section, 8.1.2.3
    types and groups, 8.1.2
    zone, 8.1.2.1
  section group
    about, 3.3.1
    and section types, 8.1.2
    creating with admin tool, 10.6
  section searching
    about, 4.1.12, 8.1
    enabling, 8.1.1
    HTML, 8.2.1
  sectioner
    about, 3.1.3.3
  sectioning
    automatic, 8.3.1
    path, 8.3.4
  security improvements in current release, 11.2.1
  self-tipping couch, A.1
  SGA memory allocation, 7.8.2
  simple classification, see rule-based classification
  single themes
    obtaining, 5.2.1.2.1
  size of index, viewing, 10.4
  skipjoins character, 3.2.6.2
  SORT_AREA_SIZE, 7.6, 7.7.10, 7.8.2
  special characters
    indexing, 3.2.6
  special sections, 8.1.2.6
  spelling
    alternate, 3.2.8.3
  SQE operator, 4.2.7
  statistics
    exporting and importing, 7.1
    optimizing with, 7.1.1
  stem operator, 3.2.9, 4.2.5
  stemming
    default, 3.3.6.2
    improving performance, 7.7.13
  stop section, 8.1.2.3
  stopclass, 3.3.4.2, 3.3.4.2
  stoplist, 3.3.4
    about, 3.3.1
    creating with admin tool, 10.6
    default, 3.3.6.2
    multi-language, 3.2.12.1, 3.3.4.1
    PL/SQL procedures, 3.3.4.3
  stoptheme, 3.3.4.2, 3.3.4.2
    about, 3.2.12
    definition, 4.1.6.1
  stopword, 3.3.4, 3.3.4.2
    about, 3.2.12, 4.1.5
    case-sensitive, 4.1.8.1.1
  storage
    about, 3.3.1
  STORE_SQE procedure, 4.2.7, 4.2.7.1
  stored query expressions, 4.2.7
  storing text, 3.2.1
    about, 3.2.1.2
  structure of index, 3.5.3.1
  structured query
    example, 3.3.7
  supervised classification, 6.4
    Decision Tree, 6.4.1
  SVM supervised classification, 6.4.2
    memory requirements, 6.4.2
  SYN operator, 9.2.1
  SYNC_INDEX procedure, 2.3, 3.5.2.1
  synching and optimizing other indexes, 11.2.1.5, 11.2.1.6
  synchronize index, 2.3
  synchronizing index, 3.5.2, 10.5
    improving performance, 7.9
  synonyms
    defining, 9.2.1

## T

  talking pillow, A.1
  template queries, 4.2.6, 4.3.1
  text column
    supported types, 3.2.1.1
  TEXT format column value, 3.2.2.2
  text highlighting, 5.1.1
  Text Manager tool, 10.6
  text storage, 3.2.1
  theme functionality
    adding, 9.4.1
  theme highlighting, 5.1.2
  theme summary
    definition, 5.2
  themes
    indexing, 3.2.8.1
  THEMES procedure, 5.2.1
  thesaural queries
    about, 4.1.11
  thesaurus
    about, 9.1
    adding to knowledge base, 9.3.2
    case-sensitive, 9.1.2
    DEFAULT, 9.1.4
    default, 9.1.4
    defining terms, 9.2
    hierarchical relations, 9.2.2
    loading custom, 9.3.1
    operators, 9.1.1.2
    supplied, 9.1.5
    using in application, 9.3
  thesaurus operator, 4.2.5
  throughput
    improving query, 7.3
  tildes
    indexing characters with, 3.2.8.2
  TOKEN_INFO, 10.4
  TOKEN_TYPE, 10.4
  tracing, 7.4
  TRAIN procedure, 6.4
  tuning queries
    for response time, 7.2
    for throughput, 7.3
    increasing result buffer size, 7.6
    with statistics, 7.1

## U

  umlauts
    indexing characters with, 3.2.8.2
  unsupervised classification, 6.5
  updating index performance
    FAQs, 7.9
  updating your applications, 11
  URL_DATASTORE
    about, 3.2.1.8
    example, 3.3.2.1.3
  URLs
    storing, 3.2.1.4
  user
    creating Oracle Text, 2.2
    system-defined, 10.1
  USER_DATASTORE, 3.1.7
    about, 3.2.1.8
  USER_FILTER, 3.2.2.3

## V

  VARCHAR2 column, 3.2.1.1
  viewing information on indexes and queries, 10.4
  viewing size of index, 10.4
  views
    and indexing, 3.1.7
    materialized

## W

  wildcard operator, 4.2.5
    improving performance, 7.7.13
  WITHIN operator, 3.3.3
  wizard
    Oracle Text addin, 2.3.1, A, B
  word query, 4.1.4
    case-sensitivity, 4.1.8.1
  wordlist
    about, 3.3.1

## X

  XML DB, 1.6
  XML documents
    attribute searching, 8.3.2
    doctype sensitive sections, 8.3.3
    indexing, 8.1.1.1
    section searching, 8.3
  XML searching, 1.6
  XML_SECTION_GROUP object, 8.1.1.1

## Z

  zone section
    definition, 8.1.2.1
    nested, 8.1.2.1.3
    overlapping, 8.1.2.1.2
    repeating, 8.1.2.1.1